Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	2014
Missing cells	78
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	363.5 KiB
Average record size in memory	184.8 B

Variable types

Categorical	2
Numeric	16

Alerts

`Symbol` has constant value "RELIANCE"	Constant
`Series` has constant value "EQ"	Constant
`Prev Close` is highly overall correlated with `Open` and 10 other fields	High correlation
`Open` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`High` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`Low` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`Last` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`Close` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`VWAP` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`Volume` is highly overall correlated with `Turnover` and 2 other fields	High correlation
`Turnover` is highly overall correlated with `Prev Close` and 12 other fields	High correlation
`Trades` is highly overall correlated with `Prev Close` and 12 other fields	High correlation
`Deliverable Volume` is highly overall correlated with `Volume` and 2 other fields	High correlation
`MA for 10 days` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`MA for 20 days` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`MA for 50 days` is highly overall correlated with `Prev Close` and 10 other fields	High correlation
`MA for 50 days` has 49 (2.4%) missing values	Missing
`Volume` has unique values	Unique
`Turnover` has unique values	Unique
`Deliverable Volume` has unique values	Unique

Reproduction

Analysis started	2023-03-15 12:42:05.618418
Analysis finished	2023-03-15 12:43:13.142435
Duration	1 minute and 7.52 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Symbol
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	96.0 KiB

RELIANCE	2014

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	16112
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RELIANCE
2nd row	RELIANCE
3rd row	RELIANCE
4th row	RELIANCE
5th row	RELIANCE

Common Values

Value	Count	Frequency (%)
RELIANCE	2014	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
reliance	2014	100.0%

Most occurring characters

Value	Count	Frequency (%)
E	4028	25.0%
R	2014	12.5%
L	2014	12.5%
I	2014	12.5%
A	2014	12.5%
N	2014	12.5%
C	2014	12.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16112	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	4028	25.0%
R	2014	12.5%
L	2014	12.5%
I	2014	12.5%
A	2014	12.5%
N	2014	12.5%
C	2014	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16112	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	4028	25.0%
R	2014	12.5%
L	2014	12.5%
I	2014	12.5%
A	2014	12.5%
N	2014	12.5%
C	2014	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16112	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	4028	25.0%
R	2014	12.5%
L	2014	12.5%
I	2014	12.5%
A	2014	12.5%
N	2014	12.5%
C	2014	12.5%

Series
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	96.0 KiB

EQ	2014

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	4028
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EQ
2nd row	EQ
3rd row	EQ
4th row	EQ
5th row	EQ

Common Values

Value	Count	Frequency (%)
EQ	2014	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
eq	2014	100.0%

Most occurring characters

Value	Count	Frequency (%)
E	2014	50.0%
Q	2014	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4028	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	2014	50.0%
Q	2014	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4028	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	2014	50.0%
Q	2014	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4028	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	2014	50.0%
Q	2014	50.0%

Prev Close
Real number (ℝ)

Distinct	1938
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1510.4711

Minimum	780.9
Maximum	2819.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	780.9
5-th percentile	876.6775
Q1	996.1125
median	1281.6
Q3	2077.075
95-th percentile	2590.385
Maximum	2819.85
Range	2038.95
Interquartile range (IQR)	1080.9625

Descriptive statistics

Standard deviation	600.61964
Coefficient of variation (CV)	0.39763729
Kurtosis	-1.0655732
Mean	1510.4711
Median Absolute Deviation (MAD)	334.925
Skewness	0.66054828
Sum	3042088.8
Variance	360743.96
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
978.95	4	0.2%
2619.05	2	0.1%
1964.05	2	0.1%
1089.4	2	0.1%
2577.8	2	0.1%
1096.35	2	0.1%
2606.6	2	0.1%
904.35	2	0.1%
950.35	2	0.1%
2479.85	2	0.1%
Other values (1928)	1992	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
780.9	1	< 0.1%
786.45	1	< 0.1%
798.35	1	< 0.1%
799.15	1	< 0.1%
810.75	1	< 0.1%
811.7	1	< 0.1%
816.9	1	< 0.1%
817.4	1	< 0.1%
817.9	1	< 0.1%
818.1	1	< 0.1%

Value	Count	Frequency (%)
2819.85	1	< 0.1%
2798.75	1	< 0.1%
2790.25	1	< 0.1%
2782.1	1	< 0.1%
2780.45	1	< 0.1%
2779.5	1	< 0.1%
2778.35	1	< 0.1%
2775.65	1	< 0.1%
2772.75	1	< 0.1%
2767.55	1	< 0.1%

Open
Real number (ℝ)

Distinct	1726
Distinct (%)	85.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1512.3259

Minimum	791.75
Maximum	2856.15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	791.75
5-th percentile	878.2925
Q1	995.925
median	1285.05
Q3	2080.75
95-th percentile	2588.0875
Maximum	2856.15
Range	2064.4
Interquartile range (IQR)	1084.825

Descriptive statistics

Standard deviation	601.39451
Coefficient of variation (CV)	0.39766197
Kurtosis	-1.0741362
Mean	1512.3259
Median Absolute Deviation (MAD)	338.575
Skewness	0.65663571
Sum	3045824.4
Variance	361675.35
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
950	7	0.3%
2085	5	0.2%
2600	5	0.2%
1375	4	0.2%
1006	4	0.2%
880	4	0.2%
930	4	0.2%
1095	4	0.2%
1028	4	0.2%
2610	4	0.2%
Other values (1716)	1969	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
791.75	1	< 0.1%
795	1	< 0.1%
799.2	1	< 0.1%
799.65	1	< 0.1%
815	1	< 0.1%
816.6	1	< 0.1%
818	1	< 0.1%
820	1	< 0.1%
821.3	1	< 0.1%
821.7	1	< 0.1%

Value	Count	Frequency (%)
2856.15	1	< 0.1%
2809.95	1	< 0.1%
2785	1	< 0.1%
2780	1	< 0.1%
2772.75	1	< 0.1%
2771.9	1	< 0.1%
2769.9	1	< 0.1%
2762	1	< 0.1%
2758.9	1	< 0.1%
2755.85	1	< 0.1%

High
Real number (ℝ)

Distinct	1831
Distinct (%)	90.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1529.2465

Minimum	793.4
Maximum	2856.15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	793.4
5-th percentile	889.79
Q1	1006.475
median	1296.975
Q3	2100.3625
95-th percentile	2610.895
Maximum	2856.15
Range	2062.75
Interquartile range (IQR)	1093.8875

Descriptive statistics

Standard deviation	607.59265
Coefficient of variation (CV)	0.39731504
Kurtosis	-1.07548
Mean	1529.2465
Median Absolute Deviation (MAD)	339.5
Skewness	0.6550909
Sum	3079902.5
Variance	369168.83
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	5	0.2%
982	4	0.2%
1550	4	0.2%
1015	4	0.2%
905	3	0.1%
952.8	3	0.1%
926	3	0.1%
1281	3	0.1%
1009	3	0.1%
1327	3	0.1%
Other values (1821)	1979	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
793.4	1	< 0.1%
802.9	1	< 0.1%
803.85	1	< 0.1%
817.7	1	< 0.1%
823.25	1	< 0.1%
824.95	1	< 0.1%
825	1	< 0.1%
825.7	1	< 0.1%
826.85	1	< 0.1%
827.05	1	< 0.1%

Value	Count	Frequency (%)
2856.15	1	< 0.1%
2851	1	< 0.1%
2828	1	< 0.1%
2817.35	1	< 0.1%
2814	1	< 0.1%
2805.5	1	< 0.1%
2803	1	< 0.1%
2802	1	< 0.1%
2795	1	< 0.1%
2791.1	1	< 0.1%

Low
Real number (ℝ)

Distinct	1816
Distinct (%)	90.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1494.6506

Minimum	779.1
Maximum	2786.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	779.1
5-th percentile	866.685
Q1	986.5375
median	1272.425
Q3	2046.3125
95-th percentile	2566
Maximum	2786.1
Range	2007
Interquartile range (IQR)	1059.775

Descriptive statistics

Standard deviation	594.53419
Coefficient of variation (CV)	0.3977747
Kurtosis	-1.0666238
Mean	1494.6506
Median Absolute Deviation (MAD)	335.375
Skewness	0.66001119
Sum	3010226.2
Variance	353470.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	5	0.2%
2495	4	0.2%
1325	4	0.2%
920	4	0.2%
990	4	0.2%
1047	4	0.2%
935	4	0.2%
2360	3	0.1%
1932	3	0.1%
978	3	0.1%
Other values (1806)	1976	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
779.1	1	< 0.1%
780.2	1	< 0.1%
785.35	1	< 0.1%
795.5	1	< 0.1%
795.6	1	< 0.1%
796.45	1	< 0.1%
801.45	1	< 0.1%
805.2	1	< 0.1%
812.1	1	< 0.1%
812.2	1	< 0.1%

Value	Count	Frequency (%)
2786.1	1	< 0.1%
2777.3	1	< 0.1%
2758.05	1	< 0.1%
2755.05	1	< 0.1%
2752.05	1	< 0.1%
2751.8	1	< 0.1%
2744.2	1	< 0.1%
2742	1	< 0.1%
2732	1	< 0.1%
2716.3	1	< 0.1%

Last
Real number (ℝ)

Distinct	1819
Distinct (%)	90.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1511.1901

Minimum	781.2
Maximum	2810
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	781.2
5-th percentile	877
Q1	995.6
median	1282
Q3	2077.575
95-th percentile	2589
Maximum	2810
Range	2028.8
Interquartile range (IQR)	1081.975

Descriptive statistics

Standard deviation	600.76329
Coefficient of variation (CV)	0.39754316
Kurtosis	-1.0702134
Mean	1511.1901
Median Absolute Deviation (MAD)	336.025
Skewness	0.65778603
Sum	3043536.9
Variance	360916.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
842	4	0.2%
2112	4	0.2%
1330	4	0.2%
895	4	0.2%
1040	3	0.1%
2178	3	0.1%
2525	3	0.1%
2668	3	0.1%
1089	3	0.1%
1288	3	0.1%
Other values (1809)	1980	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
781.2	1	< 0.1%
786.25	1	< 0.1%
798.4	1	< 0.1%
799	1	< 0.1%
810	1	< 0.1%
814.1	1	< 0.1%
816.6	1	< 0.1%
816.95	2	0.1%
819.2	1	< 0.1%
819.5	1	< 0.1%

Value	Count	Frequency (%)
2810	1	< 0.1%
2799.7	1	< 0.1%
2796.05	1	< 0.1%
2788.2	1	< 0.1%
2782	1	< 0.1%
2780.9	1	< 0.1%
2778	1	< 0.1%
2776	1	< 0.1%
2767.05	1	< 0.1%
2766.25	1	< 0.1%

Close
Real number (ℝ)

Distinct	1938
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1511.2361

Minimum	780.9
Maximum	2819.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	780.9
5-th percentile	876.6775
Q1	996.375
median	1281.75
Q3	2077.225
95-th percentile	2590.385
Maximum	2819.85
Range	2038.95
Interquartile range (IQR)	1080.85

Descriptive statistics

Standard deviation	600.81166
Coefficient of variation (CV)	0.39756305
Kurtosis	-1.0692263
Mean	1511.2361
Median Absolute Deviation (MAD)	335.075
Skewness	0.65842999
Sum	3043629.6
Variance	360974.65
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
978.95	4	0.2%
1010.4	2	0.1%
904.35	2	0.1%
2577.8	2	0.1%
969.15	2	0.1%
876.45	2	0.1%
1109.4	2	0.1%
1089.4	2	0.1%
1096.35	2	0.1%
950.35	2	0.1%
Other values (1928)	1992	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
780.9	1	< 0.1%
786.45	1	< 0.1%
798.35	1	< 0.1%
799.15	1	< 0.1%
810.75	1	< 0.1%
811.7	1	< 0.1%
816.9	1	< 0.1%
817.4	1	< 0.1%
817.9	1	< 0.1%
818.1	1	< 0.1%

Value	Count	Frequency (%)
2819.85	1	< 0.1%
2798.75	1	< 0.1%
2790.25	1	< 0.1%
2782.1	1	< 0.1%
2780.45	1	< 0.1%
2779.5	1	< 0.1%
2778.35	1	< 0.1%
2775.65	1	< 0.1%
2772.75	1	< 0.1%
2767.55	1	< 0.1%

VWAP
Real number (ℝ)

Distinct	1995
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1512.2102

Minimum	785.51
Maximum	2823.91
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	785.51
5-th percentile	878.187
Q1	996.7325
median	1284.395
Q3	2075.69
95-th percentile	2586.1105
Maximum	2823.91
Range	2038.4
Interquartile range (IQR)	1078.9575

Descriptive statistics

Standard deviation	601.06692
Coefficient of variation (CV)	0.39747578
Kurtosis	-1.0714121
Mean	1512.2102
Median Absolute Deviation (MAD)	336.64
Skewness	0.6574741
Sum	3045591.3
Variance	361281.44
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1024.42	2	0.1%
923.12	2	0.1%
981.35	2	0.1%
1240.68	2	0.1%
850.31	2	0.1%
1022.77	2	0.1%
941.25	2	0.1%
2540.02	2	0.1%
848.94	2	0.1%
916.3	2	0.1%
Other values (1985)	1994	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
785.51	1	< 0.1%
789.61	1	< 0.1%
797.81	1	< 0.1%
805.86	1	< 0.1%
807.78	1	< 0.1%
811.68	1	< 0.1%
815.7	1	< 0.1%
817.3	1	< 0.1%
818.09	1	< 0.1%
819.18	1	< 0.1%

Value	Count	Frequency (%)
2823.91	1	< 0.1%
2817.63	1	< 0.1%
2794.98	1	< 0.1%
2793.34	1	< 0.1%
2783.29	1	< 0.1%
2775.79	1	< 0.1%
2773.48	1	< 0.1%
2773.03	1	< 0.1%
2768.55	1	< 0.1%
2763.87	1	< 0.1%

Volume
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	2014
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7725705.9

Minimum	299511
Maximum	65230894
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	299511
5-th percentile	2094310.9
Q1	3756861
median	5922311.5
Q3	9296069.5
95-th percentile	19590671
Maximum	65230894
Range	64931383
Interquartile range (IQR)	5539208.5

Descriptive statistics

Standard deviation	6640182.1
Coefficient of variation (CV)	0.85949196
Kurtosis	16.674465
Mean	7725705.9
Median Absolute Deviation (MAD)	2521459
Skewness	3.2509426
Sum	1.5559572 × 10¹⁰
Variance	4.4092018 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
677439	1	< 0.1%
15784612	1	< 0.1%
17521196	1	< 0.1%
27781772	1	< 0.1%
48828852	1	< 0.1%
18677694	1	< 0.1%
19282519	1	< 0.1%
23623299	1	< 0.1%
24509162	1	< 0.1%
17790565	1	< 0.1%
Other values (2004)	2004	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
299511	1	< 0.1%
362170	1	< 0.1%
677439	1	< 0.1%
787160	1	< 0.1%
815433	1	< 0.1%
911410	1	< 0.1%
999364	1	< 0.1%
1127113	1	< 0.1%
1195257	1	< 0.1%
1238135	1	< 0.1%

Value	Count	Frequency (%)
65230894	1	< 0.1%
64751766	1	< 0.1%
64458598	1	< 0.1%
61711388	1	< 0.1%
55656793	1	< 0.1%
48828852	1	< 0.1%
47923444	1	< 0.1%
46029119	1	< 0.1%
45857806	1	< 0.1%
42477225	1	< 0.1%

Turnover
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	2014
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.238188 × 10¹⁵

Minimum	2.7819327 × 10¹³
Maximum	1.4734336 × 10¹⁶
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	2.7819327 × 10¹³
5-th percentile	2.0565337 × 10¹⁴
Q1	4.0965442 × 10¹⁴
median	9.1359204 × 10¹⁴
Q3	1.5849121 × 10¹⁵
95-th percentile	3.3837387 × 10¹⁵
Maximum	1.4734336 × 10¹⁶
Range	1.4706517 × 10¹⁶
Interquartile range (IQR)	1.1752576 × 10¹⁵

Descriptive statistics

Standard deviation	1.2615303 × 10¹⁵
Coefficient of variation (CV)	1.018852
Kurtosis	19.233525
Mean	1.238188 × 10¹⁵
Median Absolute Deviation (MAD)	5.4360752 × 10¹⁴
Skewness	3.3779508
Sum	2.4937106 × 10¹⁸
Variance	1.5914588 × 10³⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.013058524 × 10¹³	1	< 0.1%
2.478556088 × 10¹⁵	1	< 0.1%
3.034431052 × 10¹⁵	1	< 0.1%
4.920665189 × 10¹⁵	1	< 0.1%
8.434432145 × 10¹⁵	1	< 0.1%
3.056409828 × 10¹⁵	1	< 0.1%
3.121151894 × 10¹⁵	1	< 0.1%
3.820298264 × 10¹⁵	1	< 0.1%
3.90527372 × 10¹⁵	1	< 0.1%
2.76230181 × 10¹⁵	1	< 0.1%
Other values (2004)	2004	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.781932654 × 10¹³	1	< 0.1%
3.812023602 × 10¹³	1	< 0.1%
6.013058524 × 10¹³	1	< 0.1%
9.051701818 × 10¹³	1	< 0.1%
1.083937776 × 10¹⁴	1	< 0.1%
1.130270449 × 10¹⁴	1	< 0.1%
1.219206576 × 10¹⁴	1	< 0.1%
1.254250672 × 10¹⁴	1	< 0.1%
1.257352825 × 10¹⁴	1	< 0.1%
1.270670776 × 10¹⁴	1	< 0.1%

Value	Count	Frequency (%)
1.473433631 × 10¹⁶	1	< 0.1%
1.236079553 × 10¹⁶	1	< 0.1%
1.184668763 × 10¹⁶	1	< 0.1%
9.211999493 × 10¹⁵	1	< 0.1%
9.179980463 × 10¹⁵	1	< 0.1%
8.912049493 × 10¹⁵	1	< 0.1%
8.839332015 × 10¹⁵	1	< 0.1%
8.835029614 × 10¹⁵	1	< 0.1%
8.750594271 × 10¹⁵	1	< 0.1%
8.599389887 × 10¹⁵	1	< 0.1%

Trades
Real number (ℝ)

Distinct	2008
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	190194.53

Minimum	8723
Maximum	1428490
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	8723
5-th percentile	56567.25
Q1	92076.5
median	158245
Q3	234462
95-th percentile	456520.65
Maximum	1428490
Range	1419767
Interquartile range (IQR)	142385.5

Descriptive statistics

Standard deviation	142424.05
Coefficient of variation (CV)	0.74883354
Kurtosis	12.316083
Mean	190194.53
Median Absolute Deviation (MAD)	69664
Skewness	2.6832379
Sum	3.8305179 × 10⁸
Variance	2.0284609 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
92076	2	0.1%
91666	2	0.1%
63040	2	0.1%
169662	2	0.1%
219641	2	0.1%
116207	2	0.1%
467105	1	< 0.1%
424919	1	< 0.1%
299203	1	< 0.1%
327308	1	< 0.1%
Other values (1998)	1998	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8723	1	< 0.1%
9214	1	< 0.1%
9771	1	< 0.1%
16263	1	< 0.1%
28170	1	< 0.1%
29486	1	< 0.1%
30701	1	< 0.1%
31269	1	< 0.1%
31291	1	< 0.1%
33745	1	< 0.1%

Value	Count	Frequency (%)
1428490	1	< 0.1%
1285533	1	< 0.1%
1233053	1	< 0.1%
1194059	1	< 0.1%
1165095	1	< 0.1%
1154959	1	< 0.1%
1078097	1	< 0.1%
990935	1	< 0.1%
888904	1	< 0.1%
855344	1	< 0.1%

Deliverable Volume
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	2014
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3347981.6

Minimum	98030
Maximum	19734107
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	98030
5-th percentile	1059303.9
Q1	1921533.8
median	2779887.5
Q3	4091048.8
95-th percentile	7775210.8
Maximum	19734107
Range	19636077
Interquartile range (IQR)	2169515

Descriptive statistics

Standard deviation	2267164.6
Coefficient of variation (CV)	0.67717356
Kurtosis	9.1557832
Mean	3347981.6
Median Absolute Deviation (MAD)	1022878
Skewness	2.373249
Sum	6.7428349 × 10⁹
Variance	5.1400353 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
286377	1	< 0.1%
4083577	1	< 0.1%
2789706	1	< 0.1%
7287358	1	< 0.1%
15752717	1	< 0.1%
7786788	1	< 0.1%
7420780	1	< 0.1%
5774484	1	< 0.1%
5136354	1	< 0.1%
4514688	1	< 0.1%
Other values (2004)	2004	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
98030	1	< 0.1%
125224	1	< 0.1%
286377	1	< 0.1%
347306	1	< 0.1%
402932	1	< 0.1%
418584	1	< 0.1%
436975	1	< 0.1%
440625	1	< 0.1%
499595	1	< 0.1%
518886	1	< 0.1%

Value	Count	Frequency (%)
19734107	1	< 0.1%
19195053	1	< 0.1%
19148342	1	< 0.1%
18435434	1	< 0.1%
17737691	1	< 0.1%
16920113	1	< 0.1%
16124097	1	< 0.1%
15752717	1	< 0.1%
15742153	1	< 0.1%
15175508	1	< 0.1%

%Deliverble
Real number (ℝ)

Distinct	1615
Distinct (%)	80.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.48103054

Minimum	0.1148
Maximum	0.827
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	0.1148
5-th percentile	0.2602
Q1	0.399225
median	0.49225
Q3	0.56685
95-th percentile	0.67247
Maximum	0.827
Range	0.7122
Interquartile range (IQR)	0.167625

Descriptive statistics

Standard deviation	0.12358781
Coefficient of variation (CV)	0.25692301
Kurtosis	-0.23450004
Mean	0.48103054
Median Absolute Deviation (MAD)	0.0833
Skewness	-0.22716141
Sum	968.7955
Variance	0.015273948
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.5527	5	0.2%
0.5752	4	0.2%
0.529	4	0.2%
0.5715	4	0.2%
0.3873	4	0.2%
0.4576	4	0.2%
0.538	4	0.2%
0.4933	3	0.1%
0.4345	3	0.1%
0.5542	3	0.1%
Other values (1605)	1976	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1148	1	< 0.1%
0.1291	1	< 0.1%
0.136	1	< 0.1%
0.142	1	< 0.1%
0.1479	1	< 0.1%
0.1508	1	< 0.1%
0.154	1	< 0.1%
0.1585	1	< 0.1%
0.1601	1	< 0.1%
0.1615	1	< 0.1%

Value	Count	Frequency (%)
0.827	1	< 0.1%
0.8217	1	< 0.1%
0.8197	1	< 0.1%
0.8024	1	< 0.1%
0.7991	1	< 0.1%
0.7897	1	< 0.1%
0.7789	1	< 0.1%
0.7769	1	< 0.1%
0.7732	2	0.1%
0.7687	1	< 0.1%

MA for 10 days
Real number (ℝ)

Distinct	1998
Distinct (%)	99.7%
Missing	9
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	1510.7758

Minimum	810.395
Maximum	2759.255
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	810.395
5-th percentile	881.626
Q1	998.695
median	1278.31
Q3	2074.815
95-th percentile	2589.118
Maximum	2759.255
Range	1948.86
Interquartile range (IQR)	1076.12

Descriptive statistics

Standard deviation	598.45637
Coefficient of variation (CV)	0.3961252
Kurtosis	-1.0753974
Mean	1510.7758
Median Absolute Deviation (MAD)	330.45
Skewness	0.66268773
Sum	3029105.5
Variance	358150.03
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1283.88	2	0.1%
972.335	2	0.1%
922.235	2	0.1%
927.785	2	0.1%
1032.82	2	0.1%
1017.77	2	0.1%
836.635	2	0.1%
2079.5	1	< 0.1%
1524.805	1	< 0.1%
2109.65	1	< 0.1%
Other values (1988)	1988	98.7%
(Missing)	9	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
810.395	1	< 0.1%
810.825	1	< 0.1%
811.72	1	< 0.1%
813.125	1	< 0.1%
813.885	1	< 0.1%
815.1	1	< 0.1%
815.89	1	< 0.1%
819.82	1	< 0.1%
823.25	1	< 0.1%
825.91	1	< 0.1%

Value	Count	Frequency (%)
2759.255	1	< 0.1%
2753.97	1	< 0.1%
2751.5	1	< 0.1%
2735.355	1	< 0.1%
2730.31	1	< 0.1%
2721.21	1	< 0.1%
2721.02	1	< 0.1%
2720.565	1	< 0.1%
2716.845	1	< 0.1%
2711.305	1	< 0.1%

MA for 20 days
Real number (ℝ)

Distinct	1992
Distinct (%)	99.8%
Missing	19
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	1510.2945

Minimum	822.5425
Maximum	2679.87
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	822.5425
5-th percentile	885.09175
Q1	1000.2987
median	1277.8575
Q3	2080.505
95-th percentile	2591.608
Maximum	2679.87
Range	1857.3275
Interquartile range (IQR)	1080.2063

Descriptive statistics

Standard deviation	596.07571
Coefficient of variation (CV)	0.39467515
Kurtosis	-1.0787935
Mean	1510.2945
Median Absolute Deviation (MAD)	326.0775
Skewness	0.66830362
Sum	3013037.5
Variance	355306.25
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1274.5875	2	0.1%
1084.845	2	0.1%
918.56	2	0.1%
1537.3525	1	< 0.1%
1671.7875	1	< 0.1%
1661.4775	1	< 0.1%
1652.45	1	< 0.1%
1642.6525	1	< 0.1%
1634.2325	1	< 0.1%
1624.0925	1	< 0.1%
Other values (1982)	1982	98.4%
(Missing)	19	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
822.5425	1	< 0.1%
823.49	1	< 0.1%
824.1775	1	< 0.1%
825.4425	1	< 0.1%
826.2625	1	< 0.1%
827.45	1	< 0.1%
829.08	1	< 0.1%
830.83	1	< 0.1%
832.27	1	< 0.1%
836.065	1	< 0.1%

Value	Count	Frequency (%)
2679.87	1	< 0.1%
2678.73	1	< 0.1%
2678.46	1	< 0.1%
2677.98	1	< 0.1%
2673.4225	1	< 0.1%
2670.695	1	< 0.1%
2668.5125	1	< 0.1%
2664.83	1	< 0.1%
2664.04	1	< 0.1%
2662.3175	1	< 0.1%

MA for 50 days
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1960
Distinct (%)	99.7%
Missing	49
Missing (%)	2.4%
Infinite	0
Infinite (%)	0.0%
Mean	1507.6801

Minimum	865.413
Maximum	2637.976
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	865.413
5-th percentile	894.9994
Q1	997.42
median	1281.859
Q3	2039.698
95-th percentile	2544.609
Maximum	2637.976
Range	1772.563
Interquartile range (IQR)	1042.278

Descriptive statistics

Standard deviation	587.59745
Coefficient of variation (CV)	0.38973615
Kurtosis	-1.0701835
Mean	1507.6801
Median Absolute Deviation (MAD)	317.169
Skewness	0.6864652
Sum	2962591.4
Variance	345270.76
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
870.367	2	0.1%
934.804	2	0.1%
917.169	2	0.1%
2495.292	2	0.1%
2535.442	2	0.1%
1576.498	1	< 0.1%
1569.133	1	< 0.1%
1561.004	1	< 0.1%
1551.386	1	< 0.1%
1584.42	1	< 0.1%
Other values (1950)	1950	96.8%
(Missing)	49	2.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
865.413	1	< 0.1%
865.46	1	< 0.1%
865.896	1	< 0.1%
866.086	1	< 0.1%
866.178	1	< 0.1%
866.323	1	< 0.1%
867.268	1	< 0.1%
867.426	1	< 0.1%
867.779	1	< 0.1%
868.609	1	< 0.1%

Value	Count	Frequency (%)
2637.976	1	< 0.1%
2637.775	1	< 0.1%
2637.642	1	< 0.1%
2636.451	1	< 0.1%
2636.142	1	< 0.1%
2634.377	1	< 0.1%
2633.656	1	< 0.1%
2632.606	1	< 0.1%
2632.361	1	< 0.1%
2632.136	1	< 0.1%

Daily Return
Real number (ℝ)

Distinct	2013
Distinct (%)	100.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.00076616971

Minimum	-0.50279567
Maximum	0.14718041
Zeros	1
Zeros (%)	< 0.1%
Negative	966
Negative (%)	48.0%
Memory size	96.0 KiB

Quantile statistics

Minimum	-0.50279567
5-th percentile	-0.025294288
Q1	-0.009112736
median	0.00068062827
Q3	0.010805013
95-th percentile	0.029141456
Maximum	0.14718041
Range	0.64997608
Interquartile range (IQR)	0.019917749

Descriptive statistics

Standard deviation	0.021523551
Coefficient of variation (CV)	28.092406
Kurtosis	152.26177
Mean	0.00076616971
Median Absolute Deviation (MAD)	0.0099432576
Skewness	-6.1330118
Sum	1.5422996
Variance	0.00046326323
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02474621347	1	< 0.1%
-0.01446038427	1	< 0.1%
-0.007530976469	1	< 0.1%
0.06250377438	1	< 0.1%
0.02510291887	1	< 0.1%
-0.00145267973	1	< 0.1%
0.001951008021	1	< 0.1%
0.0162072004	1	< 0.1%
0.03323144957	1	< 0.1%
-0.02191266737	1	< 0.1%
Other values (2003)	2003	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.5027956728	1	< 0.1%
-0.1315388772	1	< 0.1%
-0.1234067663	1	< 0.1%
-0.0863483672	1	< 0.1%
-0.08617668532	1	< 0.1%
-0.08106396453	1	< 0.1%
-0.07849681418	1	< 0.1%
-0.07202434843	1	< 0.1%
-0.06874948137	1	< 0.1%
-0.06540432168	1	< 0.1%

Value	Count	Frequency (%)
0.1471804113	1	< 0.1%
0.1194022924	1	< 0.1%
0.1096305826	1	< 0.1%
0.1092404925	1	< 0.1%
0.1020325696	1	< 0.1%
0.09693658033	1	< 0.1%
0.08083846863	1	< 0.1%
0.07062715432	1	< 0.1%
0.07048282728	1	< 0.1%
0.06713421187	1	< 0.1%

Auto

Heatmap
Table

	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble	MA for 10 days	MA for 20 days	MA for 50 days	Daily Return
Prev Close	1.000	0.998	0.997	0.997	0.996	0.996	0.997	0.340	0.697	0.621	0.276	-0.197	0.991	0.978	0.943	-0.037
Open	0.998	1.000	0.999	0.999	0.998	0.998	0.999	0.339	0.697	0.621	0.275	-0.199	0.989	0.976	0.941	-0.025
High	0.997	0.999	1.000	0.999	0.999	0.999	1.000	0.350	0.706	0.631	0.285	-0.206	0.989	0.976	0.942	-0.000
Low	0.997	0.999	0.999	1.000	0.999	0.999	0.999	0.330	0.690	0.612	0.266	-0.195	0.988	0.974	0.939	0.001
Last	0.996	0.998	0.999	0.999	1.000	1.000	1.000	0.342	0.700	0.622	0.277	-0.203	0.988	0.975	0.940	0.025
Close	0.996	0.998	0.999	0.999	1.000	1.000	1.000	0.342	0.699	0.622	0.277	-0.202	0.988	0.974	0.940	0.024
VWAP	0.997	0.999	1.000	0.999	1.000	1.000	1.000	0.341	0.699	0.622	0.276	-0.202	0.989	0.975	0.940	0.007
Volume	0.340	0.339	0.350	0.330	0.342	0.342	0.341	1.000	0.894	0.866	0.900	-0.416	0.338	0.339	0.338	0.051
Turnover	0.697	0.697	0.706	0.690	0.700	0.699	0.699	0.894	1.000	0.945	0.799	-0.388	0.695	0.693	0.687	0.043
Trades	0.621	0.621	0.631	0.612	0.622	0.622	0.622	0.866	0.945	1.000	0.776	-0.375	0.619	0.621	0.616	0.009
Deliverable Volume	0.276	0.275	0.285	0.266	0.277	0.277	0.276	0.900	0.799	0.776	1.000	-0.032	0.276	0.282	0.285	0.021
%Deliverble	-0.197	-0.199	-0.206	-0.195	-0.203	-0.202	-0.202	-0.416	-0.388	-0.375	-0.032	1.000	-0.189	-0.182	-0.185	-0.109
MA for 10 days	0.991	0.989	0.989	0.988	0.988	0.988	0.989	0.338	0.695	0.619	0.276	-0.189	1.000	0.992	0.957	-0.032
MA for 20 days	0.978	0.976	0.976	0.974	0.975	0.974	0.975	0.339	0.693	0.621	0.282	-0.182	0.992	1.000	0.974	-0.033
MA for 50 days	0.943	0.941	0.942	0.939	0.940	0.940	0.940	0.338	0.687	0.616	0.285	-0.185	0.957	0.974	1.000	-0.034
Daily Return	-0.037	-0.025	-0.000	0.001	0.025	0.024	0.007	0.051	0.043	0.009	0.021	-0.109	-0.032	-0.033	-0.034	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble	MA for 10 days	MA for 20 days	MA for 50 days	Daily Return
Date
2015-01-01	RELIANCE	EQ	891.15	886.3	892.00	883.65	888.00	887.90	887.62	677439	6.013059e+13	16263	286377	0.4227	NaN	NaN	NaN	NaN
2015-01-02	RELIANCE	EQ	887.90	888.1	896.05	884.30	884.95	885.55	889.39	1675827	1.490461e+14	31269	1048543	0.6257	NaN	NaN	NaN	-0.002647
2015-01-05	RELIANCE	EQ	885.55	885.0	890.90	874.10	875.55	875.85	881.88	2309591	2.036781e+14	67035	1393132	0.6032	NaN	NaN	NaN	-0.010954
2015-01-06	RELIANCE	EQ	875.85	870.0	873.00	832.00	832.50	836.10	847.60	4258043	3.609133e+14	120767	2353273	0.5527	NaN	NaN	NaN	-0.045384
2015-01-07	RELIANCE	EQ	836.10	837.1	858.80	837.00	858.00	854.30	849.81	4736315	4.024972e+14	125939	2885468	0.6092	NaN	NaN	NaN	0.021768
2015-01-08	RELIANCE	EQ	854.30	860.1	862.90	840.15	843.00	842.05	845.70	4542457	3.841574e+14	77800	2663830	0.5864	NaN	NaN	NaN	-0.014339
2015-01-09	RELIANCE	EQ	842.05	848.4	862.00	845.00	861.50	860.30	852.15	3061366	2.608741e+14	56795	1697823	0.5546	NaN	NaN	NaN	0.021673
2015-01-12	RELIANCE	EQ	860.30	860.5	861.00	841.60	852.50	850.30	847.51	2308716	1.956662e+14	59103	1263612	0.5473	NaN	NaN	NaN	-0.011624
2015-01-13	RELIANCE	EQ	850.30	853.0	854.95	840.50	845.00	843.15	844.77	2274108	1.921107e+14	50755	1310196	0.5761	NaN	NaN	NaN	-0.008409
2015-01-14	RELIANCE	EQ	843.15	843.0	847.00	831.20	837.00	834.95	836.09	2601286	2.174913e+14	80257	1468754	0.5646	857.045	NaN	NaN	-0.009725

	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble	MA for 10 days	MA for 20 days	MA for 50 days	Daily Return
Date
2023-02-02	RELIANCE	EQ	2339.90	2318.00	2348.00	2311.00	2325.00	2326.95	2324.91	6305317	1.465932e+15	275957	4153622	0.6587	2386.130	2446.5200	2544.870	-0.005534
2023-02-03	RELIANCE	EQ	2326.95	2349.00	2349.00	2293.00	2330.00	2329.00	2318.88	11398850	2.643251e+15	406488	7973555	0.6995	2371.825	2437.2675	2539.868	0.000881
2023-02-06	RELIANCE	EQ	2329.00	2315.00	2321.00	2305.80	2312.90	2311.45	2311.92	6847679	1.583132e+15	293805	5191602	0.7582	2358.705	2425.9950	2533.745	-0.007535
2023-02-07	RELIANCE	EQ	2311.45	2312.00	2327.40	2293.00	2304.30	2305.90	2312.27	6985001	1.615123e+15	281342	4749078	0.6799	2346.265	2411.4500	2525.712	-0.002401
2023-02-08	RELIANCE	EQ	2305.90	2313.00	2359.90	2307.00	2349.65	2351.95	2344.97	9765490	2.289982e+15	283018	6767529	0.6930	2339.865	2401.1275	2518.507	0.019971
2023-02-09	RELIANCE	EQ	2351.95	2353.45	2370.85	2334.00	2353.60	2356.05	2354.91	6079228	1.431601e+15	264097	3862283	0.6353	2337.215	2392.6225	2511.001	0.001743
2023-02-10	RELIANCE	EQ	2356.05	2354.90	2354.90	2321.30	2336.50	2336.65	2331.77	4979789	1.161172e+15	188258	2634108	0.5290	2337.145	2385.8750	2503.268	-0.008234
2023-02-13	RELIANCE	EQ	2336.65	2340.20	2350.00	2313.55	2324.60	2323.35	2323.49	4777674	1.110088e+15	151763	2780205	0.5819	2333.505	2378.6625	2495.292	-0.005692
2023-02-14	RELIANCE	EQ	2323.35	2329.95	2381.90	2323.65	2380.00	2378.10	2365.58	6609564	1.563542e+15	227277	4049724	0.6127	2335.930	2375.3625	2489.205	0.023565
2023-02-15	RELIANCE	EQ	2378.10	2376.00	2437.20	2373.00	2435.05	2431.95	2417.55	15461902	3.737992e+15	338567	11644633	0.7531	2345.135	2373.0200	2484.040	0.022644

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample